﻿CREATE TABLE [dbo].[tblAccount] (
    [AccountID]         INT           IDENTITY (1, 1) NOT NULL,
    [CreateDate]        SMALLDATETIME NOT NULL,
    [CurrencyID]        INT           NOT NULL,
    [ProcessorCode]     CHAR (1)      NULL,
    [CardNumber]        varbinary(128) NULL,
    [CardExpiration]    char(7) NULL,
    [BankAccountNumber] varbinary(128) NULL,
    [BankRoutingNumber] NVARCHAR (40) NULL,
    [OwnerID]           INT           NULL,
    [Name]              NVARCHAR (50) NULL,
    [AddressID]         INT           NULL,
    [PersonID]          INT           NULL,
    [AccountTypeCode]   CHAR (1)      NOT NULL,
	[AccountCode]		char(3)	null,
	[AccountNumber]		varchar(20)	null
);

